sudo postgres

Sometimes, what if I forget the password of the default user Postgres when PostgreSQL is installed?Linux shell command input below: sudo-u postgres psql (so that you can directly login into the Postgres, and then in the inside can be added users,

postgres8.4 Installation configuration:1. Installing postgres8.4~$ sudo apt-get install PostgreSQL2. Modify the Super admin Postgres Password:Run Psql as a system user~$ sudo-u postgres psql postgresModify Postgres password

1. sudo apt-get install PostgreSQL #安装psql2. Su passwd postgres #设置postgres账户的密码3. postgresql.conf sets the value of the Listen_addresses key in the file to4. pg_hba.conf the configuration file, add the following configuration under the host all 127.

Reference: http://my.oschina.net/dddpeter/blog/116153 1. Create a user 1 Sudo-s-U postgres 2 Psql 3 postgres# CREATE USER xxxx1 with PASSWORD ' xxxx '; 4

Transferred from: http://blog.chinaunix.net/uid-7270462-id-5777877.htmlOne, configuration centralized backup server 1.1 standby installation Backup Server Software dependency packageYum-y Install PERL-DBD-PG Perl-json perl-thread-queue 1.2 Standby

Reference: https://hub.docker.com/_/postgres/https://docs.docker.com/engine/installation/debian/Using Docker for multi-instance installation is simpler, more convenient, and better isolated than the source code.Installing Docker Update the

Operating environment for Kali virtual machines 1 [Email protected]:~# apt-get Install PostgreSQL Start the service 12 [Email protected]:~# service PostgreSQL start[OK] starting PostgreSQL 9.1

= 1. Machine = PL/Proxyhostname:h08-vm08.corp.cnb.yahoo.cominet addr:10.62.245.152Bcast:10.62.245.255Mask:255.255.254.0OS: Linux 2.6.9-42.ELsmpCPU:Intel(R) Xeon(R) CPU L5320 @ 1.86GHzMemTotal: 254772 kBPg_Dir: /home/y/pgsql/data/port =

Steps that worked for me Ubuntu 8.04.2 on to removepostgres 8.3 List all Postgres Related packages dpkg-l | grep postgresii PostgreSQL 8.3.17-0ubuntu0.8.04.1 Object-relati Onal SQL Database (latest VERSIII postgresql-8.3 8.3.9-0ubuntu8.04

Found an article on the network http://www.linuxidc.com/Linux/2010-04/25232.htm, as follows: Ubuntu 9.10 under PostgreSQL 8. 4 solutions to forgotten passwords Ubuntu9.10 Next PostgreSQL 8. 4 Solutions to forgotten passwords:1. Edit the pg_hba.conf